Using the DataTable Functions with Excel and JSON

From version 7.2, there are a range of DataTable functions that support working with importing data from Excel and exporting data to Excel and JSON.

For details on the DataTable functions, see DataTable Library Object.

Also see Using the DataTable Functions and MS Excel & MS Word Without Interop Objects.

To test the functions:

1.

Download the sample project here.

2.

Copy Excel files to C:\TEMP.

3.

The example includes a callout that show how to use several of the functions.

4.

The user instances includes the DataTable of type DataTable, a JSON Object (for the export), and various business entities that will be used to create a list of student records.

5.

Run the project.

6.

Start Monitor.

7.

Open the callout.

8.

Click Import from Excel and then view the results in the Monitor.

9.

Click Remove Duplicate Records and then view the results in the Monitor.

10.

Click Export to JSON and then view the file in C:\Temp.

11.

Click List to DataTable and then view the results in Monitor

12.

Click Export to Excel and then view the file in C:\Temp.